How to: Change the default setting for output fields for all queries.
Solution:
Select 'Options...' from the 'Tools' menu, select or clear the 'Output All Fields' check box in the 'Query Design' group of the 'Tables/Queries' tab, and click 'Apply' or the 'OK'.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Tables/Queries' tab.
3) To change the default setting for output fields of all queries, do one of the following in the 'Query Design' group:
a) If the 'Output All Fields' check box is unchecked, select the check box to show all fields in the tables or queries on which a query is based.
b) If the 'Output All Fields' check box is checked, clear the check box to show only the fields added to the Query Design grid.
the Output All Fields check box
NOTE: The new setting will not affect any existing queries.
4) Do one of the following:
a) Click 'Apply' to apply the new settings and keep the 'Options' dialog box open.
NOTE: Click 'Apply' when there are changes that need to be made to settings on another tab. This avoids having to re-open the 'Options' dialog box.
b) Click 'OK' to apply the new settings and close the 'Options' dialog box.
